﻿<%@ Page Title="Izdelki" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
    CodeBehind="About.aspx.cs" Inherits="els_web.About" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <h2>
        Izdelki</h2>
    <p>
        Procesna številka
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <asp:Button ID="Button1" runat="server" Text="Išči" />
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:sledljivostConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:sledljivostConnectionString.ProviderName %>" 
            SelectCommand="SELECT * FROM asysaba04 WHERE (Procesna = ?)">
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox1" Name="ProcesnaSkupna" 
                    PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
    </p>
    <p>
        Procesna nalepka<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
        </asp:GridView>
    </p>
    <p>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:Supervisor_2008ConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:Supervisor_2008ConnectionString.ProviderName %>" 
            SelectCommand="SELECT * FROM TESTED_OBJECT WHERE Card_Id in (SELECT Card_Id FROM CARDS WHERE Card_Bar_Code=?)">
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox1" Name="Card_Bar_Code" 
                    PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
    </p>
    <p>
        AOI<asp:GridView ID="GridView2" runat="server" DataSourceID="SqlDataSource2">
        </asp:GridView>
    </p>
    <p>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
            ConnectionString="<%$ ConnectionStrings:KAKOVOSTConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:KAKOVOSTConnectionString.ProviderName %>" 
            SelectCommand="SELECT * FROM SPREMNILISTIZDELKA where PROCESNA like substring(?, 0, 10) + '%'">
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox1" Name="procesna" 
                    PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
            ConnectionString="<%$ ConnectionStrings:KAKOVOSTConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:KAKOVOSTConnectionString.ProviderName %>" 
            SelectCommand="SELECT * FROM SPREMNILISTNAPAK where PROCESNA like substring(?, 0, 10) + '%'">
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox1" Name="procesna" 
                    PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
    </p>
    <p>
        Operacije<asp:GridView ID="GridView3" runat="server" 
            DataSourceID="SqlDataSource3">
        </asp:GridView>
    </p>
    <p>
        Napake<asp:GridView ID="GridView4" runat="server" DataSourceID="SqlDataSource4">
        </asp:GridView>
    </p>
    <p>
        &nbsp;</p>
</asp:Content>
